Release 10.1A: OpenEdge Development:
Progress 4GL Reference

PROC-STATUS function

Returns the return status from a stored procedure. The return status is an integer value that indicates whether a stored procedure failed and why.

Syntax

PROC-STATUS

Example

This procedure runs the ORACLE stored procedure pcust and writes the results of the stored procedure into the Progress-supplied buffer, proc-text-buffer. The CLOSE STORED-PROCEDURE statement then retrieves the output parameters. The return status is written to the variable stat and is displayed. This same code works for accessing a stored procedure from an ODBC-compliant data source:

DEFINE VAR stat AS INTEGER. RUN STORED-PROCEDURE pcust (10, OUTPUT 0, OUTPUT 0). FOR EACH proc-text-buffer: END. CLOSE STORED-PROCEDURE pcust stat = PROC-STATUS. DISPLAY stat.

Notes

For descriptions of the possible values for the return status of a non-Progress stored procedure, see your non-Progress documentation.
For more information on using this function, see the OpenEdge DataServer Guides, OpenEdge Data Management: DataServer for Microsoft SQL Server , OpenEdge Data Management: DataServer for ODBC , and OpenEdge Data Management: DataServer for ORACLE .

See also

CLOSE STORED-PROCEDURE statement, PROC-HANDLE function, RUN STORED-PROCEDURE statement